";
$sql = "select n.nid,n.title from node n inner join node_content_document d on n.vid=d.vid $extra_join where n.type='content_document' and d.field_document_type_value<>'Newsletter' $extra_where order by n.created desc limit $len";
$result = db_query($sql);
while ($row = db_fetch_object($result)) {
$url = "http://www.ifiwatchnet.org/?q=node/".$row->nid;
print "\\n";
}
print "\");\n";
break;
case 486: // DOCUMENTS V2
print "document.write(\"";
$sql = "select n.nid,n.title,n.created,d.field_publisher_value publisher from node n inner join node_content_document d on n.vid=d.vid where n.type='content_document' and d.field_document_type_value<>'Newsletter' order by n.created desc limit $len";
$result = db_query($sql);
while ($row = db_fetch_object($result)) {
$date = date("d M Y");
$url = "http://www.ifiwatchnet.org/?q=node/".$row->nid;
print "
\\n
\\n".$row->title." \\n
\\n
\\nPublished $date".($row->publisher ? " by ".$row->publisher."" : "")." \\n
\\n
\\n";
}
print "
";
$sql = "select n.nid,n.title,n.created,d.field_author_value author,d.field_document_type_value dtype,d.field_publisher_value publisher,m.field_media_type_value mtype,b.field_description_value body from node n inner join node_content_document d on n.vid=d.vid inner join node_data_field_media_type m on n.vid=m.vid inner join node_data_field_description b on n.vid=b.vid where n.type='content_document' and d.field_document_type_value<>'Newsletter' order by n.created desc limit $len";
$result = db_query($sql);
while ($row = db_fetch_object($result)) {
$date = date("d M Y");
$url = "http://www.ifiwatchnet.org/?q=node/".$row->nid;
$teaser = node_teaser($row->body);
$teaser = str_replace("\n","
",check_plain(decode_entities(strip_tags($teaser))));
$title = str_replace("\n","
",check_plain($row->title));
print "
\\n
\\n".$title." \\n \\n
\\n
\\n
".($row->author ? "by ".$row->author : "")."
\\n
\\n$teaser\\n
\\n
\\n".$row->dtype." | ".$row->mtype." | Published $date".($row->publisher ? " by ".$row->publisher."" : "")." \\n
\\n
\\n
\\n";
}
print "
";
$sql = "select n.nid,n.title from node n inner join node_content_events d on n.vid=d.vid $extra_join where n.type='content_events' $extra_where order by d.field_start_date_value desc limit $len";
$result = db_query($sql);
while ($row = db_fetch_object($result)) {
$url = "http://www.ifiwatchnet.org/?q=node/".$row->nid;
print "
\\n";
}
print "
";
$sql = "select n.nid,n.title,d.field_city_value as city,d.field_start_date_value as start_date from node n inner join node_content_events d on n.vid=d.vid where n.type='content_events' and d.field_start_date_value > now() order by d.field_start_date_value asc limit $len";
$result = db_query($sql);
while ($row = db_fetch_object($result)) {
$date = date("d M Y",strtotime($row->start_date));
$url = "http://www.ifiwatchnet.org/?q=node/".$row->nid;
print "
\\n
\\n".$row->title." \\n
\\n
\\n$date".($row->city ? " | ".$row->city."" : "")." \\n
\\n
\\n";
}
print "
";
$sql = "select n.nid,n.title,d.field_host_1_value as host,d.field_host_1_url_value as hurl,d.field_city_value as city,d.field_start_date_value as start_date,b.field_description_value body from node n inner join node_content_events d on n.vid=d.vid inner join node_data_field_description b on n.vid=b.vid where n.type='content_events' and d.field_start_date_value > now() order by d.field_start_date_value asc limit $len";
$result = db_query($sql);
while ($row = db_fetch_object($result)) {
$date = date("d M Y",strtotime($row->start_date));
$url = "http://www.ifiwatchnet.org/?q=node/".$row->nid;
$teaser = node_teaser($row->body);
$teaser = str_replace("\n","
",check_plain(decode_entities(strip_tags($teaser))));
$host = ($row->hurl ? "
hurl." target=\\\"_blank\\\">".$row->host."" : $row->host);
print "
\\n
\\n".$row->title."\\n \\n
\\n
\\n
\\n$date".($row->city ? " | ".$row->city."" : "")."\\n
\\n
\\n".$teaser."\\n
\\n".($host ? "
\\nhost: ".$host." \\n
\\n" : "")."
\\n
\\n";
}
print "